CalendarPeriodRewardDerivationRuleEligibility

Entity Definition

Logical Name : CalendarPeriodRewardDerivationRuleEligibility
Physical Name : CO_EL_CLD_PRDV

A kind of RewardDerivationRuleEligibility that allows RewardDerivationRules to be targeted to particular CalendarPeriods (Eg: Season, SubSeason, Easter, Christmas, Thanksgiving etc..)

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RewardDerivationRuleEligibilityID (FK)(PK) A unique identifier for a Price Derivation Rule Eligibility. ID_EL_PRDV Identity integer
CalendarID (FK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer CalendarPeriod(CA_CLD_PRD)
CalendarLevelID (FK) A unique system assigned identifier for the CalendarLevel. ID_CLD_LV Identity integer CalendarPeriod(CA_CLD_PRD)
CalendarPeriodID (FK) A unique system assigned identifier for this CalendarPeriod ID_CLD_PRD Identity integer CalendarPeriod(CA_CLD_PRD)

Relationships

Parent Entity Verb Phrase Child Entity
CalendarPeriod may trigger CalendarPeriodRewardDerivationRuleEligibility
RewardEligibilityRule can be a CalendarPeriodRewardDerivationRuleEligibility

Logical Views containing CalendarPeriodRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 06100 - Calendar View